UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yQ6DyN1PBJPmsrX2oZWdyvWe6IEHZNFLAbxrWyM4UNE='
WHERE
key_id = '4cae895b9fad787d9d141a6ebfce2d5a4d810e2b9214c1ac42ef9f2b12ffceeb'
AND (
token = 'yQ6DyN1PBJPmsrX2oZWdyvWe6IEHZNFLAbxrWyM4UNE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)