UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '34SpQAG0NX8QHt9WWGIufkPCpgU7Ww12zEVjqh5BDwE='
WHERE
key_id = '7bcd9d6f8cc4fdcdfb8d815156166e5fe099b4f3db128881c801eb3bc5f9f97d'
AND (
token = '34SpQAG0NX8QHt9WWGIufkPCpgU7Ww12zEVjqh5BDwE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)