UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8CegxGAhkwgXOG4cckshmEUpIThsVSa+U+PHjc08YLA='
WHERE
key_id = '948222c81875bac61ac1bb9ffd70c4c79223952c0d787855c27eb18989c3c02c'
AND (
token = '8CegxGAhkwgXOG4cckshmEUpIThsVSa+U+PHjc08YLA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)