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