UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vSm72o4KGOjH2tAo1gqlvhyhYN+v0n7tn5eWrVbghu8='
WHERE
key_id = '242234a9157f18a2c1f89a665dd3bca99411799c55eefadc6cca6430ca7eb77b'
AND (
token = 'vSm72o4KGOjH2tAo1gqlvhyhYN+v0n7tn5eWrVbghu8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)