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