UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MI4W4XIlnKESCJPAt6gIim2WiJT/yuxec4hbl5J0AYc='
WHERE
key_id = '7173f99f886afa9ea9b03baae50dc86a54b93f188e8c288610a06f7f28eae425'
AND (
token = 'MI4W4XIlnKESCJPAt6gIim2WiJT/yuxec4hbl5J0AYc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)