UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8rp5akJYPvT47R9e10o6dSeIwJFwzENEZLArrrfIuvk='
WHERE
key_id = 'c93ea691aaf459fe20f4209fa1c179e35d31c82c4a3d4fb2976d8ec679931ed7'
AND (
token = '8rp5akJYPvT47R9e10o6dSeIwJFwzENEZLArrrfIuvk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)