UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mi3CqY/SkX/juMj1giBiZUazNHV/P9qB4xGSjA+sYIM='
WHERE
key_id = '0f601a1447f20bbd53c0265b0216eafa9f60207bc09dc64fbd1ddcc47ac8a178'
AND (
token = 'mi3CqY/SkX/juMj1giBiZUazNHV/P9qB4xGSjA+sYIM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)