UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ohSeI6yOM2nebps3J+R+QKNZfJv9Zw1kp/L7y8X5Gm0='
WHERE
key_id = '49bb3e1ad58a8a51bb1dd21c28487478d8835acd392d5838f88336a1a0ff5d2f'
AND (
token = 'ohSeI6yOM2nebps3J+R+QKNZfJv9Zw1kp/L7y8X5Gm0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)