UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nhYIhrC71KIrZe1W+wQ1T7nkQki+OFfv4YUl4QB+jw4='
WHERE
key_id = '428e6e536da55faa7f3b5b0406b4707e0871381dece8fe9d155796a6cdc106a3'
AND (
token = 'nhYIhrC71KIrZe1W+wQ1T7nkQki+OFfv4YUl4QB+jw4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)