UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0sHFEAEZE4z/J0bqM8q1tp2P1X3tr9au9DBDahdZsTI='
WHERE
key_id = 'd01450d252576d009c7a6a537adeb5a5385ac7704ed33abf9146c643bbdd3315'
AND (
token = '0sHFEAEZE4z/J0bqM8q1tp2P1X3tr9au9DBDahdZsTI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)