UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6N4DBvz0Ml2l3g1YL3aABSrNtzZAlqfTdISZNKN3nRE='
WHERE
key_id = '478546f5792eee4305c582fb75f228217f0c5cfa2dc5336da3daf4f10f8aca5e'
AND (
token = '6N4DBvz0Ml2l3g1YL3aABSrNtzZAlqfTdISZNKN3nRE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)