UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/RZ49QEEyBWrtHPfiOUOMwoojseqSguxev7zyL9m+Bo='
WHERE
key_id = 'affd2d2e5665e99ea5ade74bf81db75e168a7bd8b6e4bde182dc8afb9c7ae124'
AND (
token = '/RZ49QEEyBWrtHPfiOUOMwoojseqSguxev7zyL9m+Bo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)