UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jsOGNh3aZA+OowkfS4h3tfntDvBYfMphz20LlYMpswA='
WHERE
key_id = '678b7e1f42d6f95bc6acad067db7fc93dfe5a1943988cf651bf3a80135819181'
AND (
token = 'jsOGNh3aZA+OowkfS4h3tfntDvBYfMphz20LlYMpswA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)