UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/tMRWA4P98w1S7eU+IRKMijXZrn/PaGy1HPxZQdi0Qo='
WHERE
key_id = '0def31aa470e0c839125c163007f6a176cd82496a8b47e2a8f76553a7925e56e'
AND (
token = '/tMRWA4P98w1S7eU+IRKMijXZrn/PaGy1HPxZQdi0Qo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)