UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zxS3sB1H3BJpfvJllk7tDUI9Gmck7/TWqsCYPRQxEjs='
WHERE
key_id = '683d4944b9977a6369c4a9ad69ef8bd8229d4fe87b0eb99ae66ca25356b83d1b'
AND (
token = 'zxS3sB1H3BJpfvJllk7tDUI9Gmck7/TWqsCYPRQxEjs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)