UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cfA7davKryE/CnohIXxHlKASCuTjRfDY8UldifA1YQk='
WHERE
key_id = 'a742448d52ed209cab2eb850234160309a651cf5f44d8d1f3de4f89cc16082a6'
AND (
token = 'cfA7davKryE/CnohIXxHlKASCuTjRfDY8UldifA1YQk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)