UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wChUfn3O2Rpix49Z6WVIsad0W5aHYqozgsXfMhGl58I='
WHERE
key_id = 'c0f07ae84b52086713e6e0b80bc4b00f3080a58d7051e800ba4fd92fc7357ff7'
AND (
token = 'wChUfn3O2Rpix49Z6WVIsad0W5aHYqozgsXfMhGl58I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)