UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RoX8nWI2MOsdI8qdntM7x1Uframs++YqKbvOMhZYVmk='
WHERE
key_id = 'dd1c494dc7d009140564bc0e3af74ae7d421450494166fcd4477532d89c074f4'
AND (
token = 'RoX8nWI2MOsdI8qdntM7x1Uframs++YqKbvOMhZYVmk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)