UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sM6FogcAeIUQb3a2/iNWmf9bMCwcMgTbVFyaNKD6h38='
WHERE
key_id = 'f2cf4d28ff44eb16f2e34f63d74ea909928397321cd94592f5b04812a8788a70'
AND (
token = 'sM6FogcAeIUQb3a2/iNWmf9bMCwcMgTbVFyaNKD6h38='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)