UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zFqeLGiv034IljwIyOkQR14ZECZZhw8UiBV1zUq0jiA='
WHERE
key_id = 'fc47e529ed06cf900dc4d486347289d68dfe58be718a1381260f75d82853f0c5'
AND (
token = 'zFqeLGiv034IljwIyOkQR14ZECZZhw8UiBV1zUq0jiA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)