UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Tj3yxKAGrLjphp7UCUUpnFOg463d9V9iIis3no77vLs='
WHERE
key_id = '4f48e91edb817e205901591b76c908957300f324c906e7944bb2fb479fc10c76'
AND (
token = 'Tj3yxKAGrLjphp7UCUUpnFOg463d9V9iIis3no77vLs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)