UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4cAJS2pRatAQOMt2WXqP24n+xEXqKcNxjZv4GWjczm0='
WHERE
key_id = '56c0a5a7bab409a7bc8905f7354fb87b3c5821aa4d2c303a8ba98a8f760f1b09'
AND (
token = '4cAJS2pRatAQOMt2WXqP24n+xEXqKcNxjZv4GWjczm0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)