UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yrNgryHKbXllybPBiIrUTfEYwKUNkTMmJlFh+Hw61rk='
WHERE
key_id = 'e7ac971c0ece867955432a097dfa3063eb647b305295e0e693512f268726f6e0'
AND (
token = 'yrNgryHKbXllybPBiIrUTfEYwKUNkTMmJlFh+Hw61rk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)