UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'y3dKgmyF1jxQ6BOp4t9PIxj1ffI3/xlO01M6bdyiBL4='
WHERE
key_id = '515d4c4208425b4e7bc29c8dd7c1b0792d06a8e0a0c2caa025dc74eec85c57a0'
AND (
token = 'y3dKgmyF1jxQ6BOp4t9PIxj1ffI3/xlO01M6bdyiBL4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)