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