UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+HmVu7UxXCamsC7wuVU6jsBs4+6G2d/lSwjvZadbVJA='
WHERE
key_id = '3a7800229b3c7835cd53268636f55d6ed546f62bfd7fed3e5a0111a3b8bc7a62'
AND (
token = '+HmVu7UxXCamsC7wuVU6jsBs4+6G2d/lSwjvZadbVJA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)