UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tBZppxFDvXSExszJTGMpBPXRejlq+eAYSGifqea3Qck='
WHERE
key_id = 'a144c1420ee2d6b23f895f7bfd1b7d9d1853e269b697d8f932038b7a80a1ccd7'
AND (
token = 'tBZppxFDvXSExszJTGMpBPXRejlq+eAYSGifqea3Qck='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)