UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QhtcHuaeAOFlQnPe0njRPF4bdcicetZ0ALXBC12kLXw='
WHERE
key_id = '43145930568d24abb364b1cacb610ec3209195f20a02a12b13259dff739b305e'
AND (
token = 'QhtcHuaeAOFlQnPe0njRPF4bdcicetZ0ALXBC12kLXw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)